Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

Bind variables

The DataServer has enhanced memory management for bind variables, which causes variables in SQL statements to be rebound less frequently.

SQL SELECT statements use bind variables. When you use the SQL SELECT statement in a Progress procedure, the OpenEdge DataServer for ORACLE uses bind variables and generates reusable SQL.

For Progress queries that reference a DATE in the WHERE clause, the DataServer uses a bind variable instead of a literal for the DATE value and generates reusable SQL.

Note: The DataServer does not substitute bind variables for values in SQL statements that you send directly to ORACLE using the Progress RUN STORED-PROC send-sql-statement syntax.